﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="nSynDBDataSet" targetNamespace="http://tempuri.org/nSynDBDataSet1.xsd" xmlns:mstns="http://tempuri.org/nSynDBDataSet1.xsd" xmlns="http://tempuri.org/nSynDBDataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="nSynDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="nSynDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.nSin.Properties.Settings.GlobalReference.Default.nSynDBConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DipendenzeTableAdapter" GeneratorDataComponentClassName="DipendenzeTableAdapter" Name="Dipendenze" UserDataComponentName="DipendenzeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.Dipendenze" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Dipendenze] WHERE (([IdDipendenza] = @Original_IdDipendenza) AND ([IdSocieta] = @Original_IdSocieta) AND ([Denominazione] = @Original_Denominazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_CAB = 1 AND [CAB] IS NULL) OR ([CAB] = @Original_CAB)) AND ([Comune] = @Original_Comune) AND ([IdProvincia] = @Original_IdProvincia) AND ((@IsNull_CAP = 1 AND [CAP] IS NULL) OR ([CAP] = @Original_CAP)) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Comune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comune" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Dipendenze] ([IdSocieta], [Denominazione], [Indirizzo], [CAB], [Comune], [IdProvincia], [CAP], [DataInizio], [DataFine]) VALUES (@IdSocieta, @Denominazione, @Indirizzo, @CAB, @Comune, @IdProvincia, @CAP, @DataInizio, @DataFine);
SELECT IdDipendenza, IdSocieta, Denominazione, Indirizzo, CAB, Comune, IdProvincia, CAP, DataInizio, DataFine FROM Dipendenze WHERE (IdDipendenza = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comune" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdDipendenza, IdSocieta, Denominazione, Indirizzo, CAB, Comune, IdProvincia, CAP, DataInizio, DataFine FROM dbo.Dipendenze</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Dipendenze] SET [IdSocieta] = @IdSocieta, [Denominazione] = @Denominazione, [Indirizzo] = @Indirizzo, [CAB] = @CAB, [Comune] = @Comune, [IdProvincia] = @IdProvincia, [CAP] = @CAP, [DataInizio] = @DataInizio, [DataFine] = @DataFine WHERE (([IdDipendenza] = @Original_IdDipendenza) AND ([IdSocieta] = @Original_IdSocieta) AND ([Denominazione] = @Original_Denominazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_CAB = 1 AND [CAB] IS NULL) OR ([CAB] = @Original_CAB)) AND ([Comune] = @Original_Comune) AND ([IdProvincia] = @Original_IdProvincia) AND ((@IsNull_CAP = 1 AND [CAP] IS NULL) OR ([CAP] = @Original_CAP)) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)));
SELECT IdDipendenza, IdSocieta, Denominazione, Indirizzo, CAB, Comune, IdProvincia, CAP, DataInizio, DataFine FROM Dipendenze WHERE (IdDipendenza = @IdDipendenza)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Indirizzo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comune" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Indirizzo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Indirizzo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Indirizzo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Comune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comune" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CAP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CAP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdDipendenza" ColumnName="IdDipendenza" DataSourceName="nSynDB.dbo.Dipendenze" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdDipendenza" DataSetColumn="IdDipendenza" />
              <Mapping SourceColumn="IdSocieta" DataSetColumn="IdSocieta" />
              <Mapping SourceColumn="Denominazione" DataSetColumn="Denominazione" />
              <Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
              <Mapping SourceColumn="CAB" DataSetColumn="CAB" />
              <Mapping SourceColumn="Comune" DataSetColumn="Comune" />
              <Mapping SourceColumn="IdProvincia" DataSetColumn="IdProvincia" />
              <Mapping SourceColumn="CAP" DataSetColumn="CAP" />
              <Mapping SourceColumn="DataInizio" DataSetColumn="DataInizio" />
              <Mapping SourceColumn="DataFine" DataSetColumn="DataFine" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InformazioniAssegnazioneTableAdapter" GeneratorDataComponentClassName="InformazioniAssegnazioneTableAdapter" Name="InformazioniAssegnazione" UserDataComponentName="InformazioniAssegnazioneTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.InformazioniAssegnazione" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[InformazioniAssegnazione] WHERE (([IdAssegnazione] = @Original_IdAssegnazione) AND ([IdUtente] = @Original_IdUtente) AND ([IdSocieta] = @Original_IdSocieta) AND ([IdDipendenza] = @Original_IdDipendenza) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdAssegnazione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdAssegnazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[InformazioniAssegnazione] ([IdUtente], [IdSocieta], [IdDipendenza], [DataInizio], [DataFine]) VALUES (@IdUtente, @IdSocieta, @IdDipendenza, @DataInizio, @DataFine);
SELECT IdAssegnazione, IdUtente, IdSocieta, IdDipendenza, DataInizio, DataFine FROM InformazioniAssegnazione WHERE (IdAssegnazione = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdAssegnazione, IdUtente, IdSocieta, IdDipendenza, DataInizio, DataFine FROM dbo.InformazioniAssegnazione</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[InformazioniAssegnazione] SET [IdUtente] = @IdUtente, [IdSocieta] = @IdSocieta, [IdDipendenza] = @IdDipendenza, [DataInizio] = @DataInizio, [DataFine] = @DataFine WHERE (([IdAssegnazione] = @Original_IdAssegnazione) AND ([IdUtente] = @Original_IdUtente) AND ([IdSocieta] = @Original_IdSocieta) AND ([IdDipendenza] = @Original_IdDipendenza) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)));
SELECT IdAssegnazione, IdUtente, IdSocieta, IdDipendenza, DataInizio, DataFine FROM InformazioniAssegnazione WHERE (IdAssegnazione = @IdAssegnazione)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdAssegnazione" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdAssegnazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdAssegnazione" ColumnName="IdAssegnazione" DataSourceName="nSynDB.dbo.InformazioniAssegnazione" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdAssegnazione" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdAssegnazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdAssegnazione" DataSetColumn="IdAssegnazione" />
              <Mapping SourceColumn="IdUtente" DataSetColumn="IdUtente" />
              <Mapping SourceColumn="IdSocieta" DataSetColumn="IdSocieta" />
              <Mapping SourceColumn="IdDipendenza" DataSetColumn="IdDipendenza" />
              <Mapping SourceColumn="DataInizio" DataSetColumn="DataInizio" />
              <Mapping SourceColumn="DataFine" DataSetColumn="DataFine" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModificheUtentiTableAdapter" GeneratorDataComponentClassName="ModificheUtentiTableAdapter" Name="ModificheUtenti" UserDataComponentName="ModificheUtentiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.ModificheUtenti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ModificheUtenti] WHERE (([IdModifica] = @Original_IdModifica) AND ([IdUtente] = @Original_IdUtente) AND ([TipologiaModifica] = @Original_TipologiaModifica) AND ([ValoreContributo] = @Original_ValoreContributo) AND ([DataModifica] = @Original_DataModifica) AND ([DataInserimento] = @Original_DataInserimento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdModifica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipologiaModifica" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipologiaModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ValoreContributo" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ValoreContributo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DataModifica" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInserimento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInserimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ModificheUtenti] ([IdUtente], [TipologiaModifica], [ValoreContributo], [DataModifica], [DataInserimento]) VALUES (@IdUtente, @TipologiaModifica, @ValoreContributo, @DataModifica, @DataInserimento);
SELECT IdModifica, IdUtente, TipologiaModifica, ValoreContributo, DataModifica, DataInserimento FROM ModificheUtenti WHERE (IdModifica = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipologiaModifica" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipologiaModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ValoreContributo" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ValoreContributo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DataModifica" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInserimento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInserimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdModifica, IdUtente, TipologiaModifica, ValoreContributo, DataModifica, DataInserimento FROM dbo.ModificheUtenti</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ModificheUtenti] SET [IdUtente] = @IdUtente, [TipologiaModifica] = @TipologiaModifica, [ValoreContributo] = @ValoreContributo, [DataModifica] = @DataModifica, [DataInserimento] = @DataInserimento WHERE (([IdModifica] = @Original_IdModifica) AND ([IdUtente] = @Original_IdUtente) AND ([TipologiaModifica] = @Original_TipologiaModifica) AND ([ValoreContributo] = @Original_ValoreContributo) AND ([DataModifica] = @Original_DataModifica) AND ([DataInserimento] = @Original_DataInserimento));
SELECT IdModifica, IdUtente, TipologiaModifica, ValoreContributo, DataModifica, DataInserimento FROM ModificheUtenti WHERE (IdModifica = @IdModifica)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipologiaModifica" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipologiaModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ValoreContributo" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ValoreContributo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DataModifica" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInserimento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInserimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdModifica" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipologiaModifica" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipologiaModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ValoreContributo" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ValoreContributo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DataModifica" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DataModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInserimento" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInserimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdModifica" ColumnName="IdModifica" DataSourceName="nSynDB.dbo.ModificheUtenti" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdModifica" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdModifica" DataSetColumn="IdModifica" />
              <Mapping SourceColumn="IdUtente" DataSetColumn="IdUtente" />
              <Mapping SourceColumn="TipologiaModifica" DataSetColumn="TipologiaModifica" />
              <Mapping SourceColumn="ValoreContributo" DataSetColumn="ValoreContributo" />
              <Mapping SourceColumn="DataModifica" DataSetColumn="DataModifica" />
              <Mapping SourceColumn="DataInserimento" DataSetColumn="DataInserimento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProvincieTableAdapter" GeneratorDataComponentClassName="ProvincieTableAdapter" Name="Provincie" UserDataComponentName="ProvincieTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.Provincie" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Provincie] WHERE (([IdProvincia] = @Original_IdProvincia) AND ([Denominazione] = @Original_Denominazione) AND ([Sigla] = @Original_Sigla) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Provincie] ([Denominazione], [Sigla], [DataInizio], [DataFine]) VALUES (@Denominazione, @Sigla, @DataInizio, @DataFine);
SELECT IdProvincia, Denominazione, Sigla, DataInizio, DataFine FROM Provincie WHERE (IdProvincia = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdProvincia, Denominazione, Sigla, DataInizio, DataFine FROM dbo.Provincie</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Provincie] SET [Denominazione] = @Denominazione, [Sigla] = @Sigla, [DataInizio] = @DataInizio, [DataFine] = @DataFine WHERE (([IdProvincia] = @Original_IdProvincia) AND ([Denominazione] = @Original_Denominazione) AND ([Sigla] = @Original_Sigla) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)));
SELECT IdProvincia, Denominazione, Sigla, DataInizio, DataFine FROM Provincie WHERE (IdProvincia = @IdProvincia)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdProvincia" ColumnName="IdProvincia" DataSourceName="nSynDB.dbo.Provincie" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdProvincia" DataSetColumn="IdProvincia" />
              <Mapping SourceColumn="Denominazione" DataSetColumn="Denominazione" />
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
              <Mapping SourceColumn="DataInizio" DataSetColumn="DataInizio" />
              <Mapping SourceColumn="DataFine" DataSetColumn="DataFine" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SocietaTableAdapter" GeneratorDataComponentClassName="SocietaTableAdapter" Name="Societa" UserDataComponentName="SocietaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.Societa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Societa] WHERE (([IdSocieta] = @Original_IdSocieta) AND ([Denominazione] = @Original_Denominazione) AND ([ABI] = @Original_ABI) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ABI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ABI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Societa] ([Denominazione], [ABI], [DataInizio], [DataFine]) VALUES (@Denominazione, @ABI, @DataInizio, @DataFine);
SELECT IdSocieta, Denominazione, ABI, DataInizio, DataFine FROM Societa WHERE (IdSocieta = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ABI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ABI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdSocieta, Denominazione, ABI, DataInizio, DataFine FROM dbo.Societa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Societa] SET [Denominazione] = @Denominazione, [ABI] = @ABI, [DataInizio] = @DataInizio, [DataFine] = @DataFine WHERE (([IdSocieta] = @Original_IdSocieta) AND ([Denominazione] = @Original_Denominazione) AND ([ABI] = @Original_ABI) AND ([DataInizio] = @Original_DataInizio) AND ((@IsNull_DataFine = 1 AND [DataFine] IS NULL) OR ([DataFine] = @Original_DataFine)));
SELECT IdSocieta, Denominazione, ABI, DataInizio, DataFine FROM Societa WHERE (IdSocieta = @IdSocieta)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ABI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ABI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denominazione" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denominazione" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ABI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ABI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataInizio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataInizio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataFine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataFine" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataFine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdSocieta" ColumnName="IdSocieta" DataSourceName="nSynDB.dbo.Societa" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdSocieta" DataSetColumn="IdSocieta" />
              <Mapping SourceColumn="Denominazione" DataSetColumn="Denominazione" />
              <Mapping SourceColumn="ABI" DataSetColumn="ABI" />
              <Mapping SourceColumn="DataInizio" DataSetColumn="DataInizio" />
              <Mapping SourceColumn="DataFine" DataSetColumn="DataFine" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UtentiTableAdapter" GeneratorDataComponentClassName="UtentiTableAdapter" Name="Utenti" UserDataComponentName="UtentiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.Utenti" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Utenti] WHERE (([IdUtente] = @Original_IdUtente) AND ([Nome] = @Original_Nome) AND ([Cognome] = @Original_Cognome) AND ((@IsNull_CodiceFiscale = 1 AND [CodiceFiscale] IS NULL) OR ([CodiceFiscale] = @Original_CodiceFiscale)) AND ([IscrittoSilcea] = @Original_IscrittoSilcea) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([IdSocieta] = @Original_IdSocieta) AND ([DenominazioneSocieta] = @Original_DenominazioneSocieta) AND ([IdDipendenza] = @Original_IdDipendenza) AND ([DenominazioneDipendenza] = @Original_DenominazioneDipendenza) AND ([IdProvincia] = @Original_IdProvincia) AND ([SiglaProvincia] = @Original_SiglaProvincia) AND ([DataUltimaModifica] = @Original_DataUltimaModifica))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodiceFiscale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodiceFiscale" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_IscrittoSilcea" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="IscrittoSilcea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenominazioneSocieta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenominazioneDipendenza" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SiglaProvincia" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SiglaProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataUltimaModifica" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataUltimaModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Utenti] ([Nome], [Cognome], [CodiceFiscale], [IscrittoSilcea], [Email], [IdSocieta], [DenominazioneSocieta], [IdDipendenza], [DenominazioneDipendenza], [IdProvincia], [SiglaProvincia], [DataUltimaModifica]) VALUES (@Nome, @Cognome, @CodiceFiscale, @IscrittoSilcea, @Email, @IdSocieta, @DenominazioneSocieta, @IdDipendenza, @DenominazioneDipendenza, @IdProvincia, @SiglaProvincia, @DataUltimaModifica);
SELECT IdUtente, Nome, Cognome, CodiceFiscale, IscrittoSilcea, Email, IdSocieta, DenominazioneSocieta, IdDipendenza, DenominazioneDipendenza, IdProvincia, SiglaProvincia, DataUltimaModifica FROM Utenti WHERE (IdUtente = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodiceFiscale" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@IscrittoSilcea" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="IscrittoSilcea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenominazioneSocieta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenominazioneDipendenza" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SiglaProvincia" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SiglaProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataUltimaModifica" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataUltimaModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdUtente, Nome, Cognome, CodiceFiscale, IscrittoSilcea, Email, IdSocieta, DenominazioneSocieta, IdDipendenza, DenominazioneDipendenza, IdProvincia, SiglaProvincia, DataUltimaModifica FROM dbo.Utenti</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Utenti] SET [Nome] = @Nome, [Cognome] = @Cognome, [CodiceFiscale] = @CodiceFiscale, [IscrittoSilcea] = @IscrittoSilcea, [Email] = @Email, [IdSocieta] = @IdSocieta, [DenominazioneSocieta] = @DenominazioneSocieta, [IdDipendenza] = @IdDipendenza, [DenominazioneDipendenza] = @DenominazioneDipendenza, [IdProvincia] = @IdProvincia, [SiglaProvincia] = @SiglaProvincia, [DataUltimaModifica] = @DataUltimaModifica WHERE (([IdUtente] = @Original_IdUtente) AND ([Nome] = @Original_Nome) AND ([Cognome] = @Original_Cognome) AND ((@IsNull_CodiceFiscale = 1 AND [CodiceFiscale] IS NULL) OR ([CodiceFiscale] = @Original_CodiceFiscale)) AND ([IscrittoSilcea] = @Original_IscrittoSilcea) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ([IdSocieta] = @Original_IdSocieta) AND ([DenominazioneSocieta] = @Original_DenominazioneSocieta) AND ([IdDipendenza] = @Original_IdDipendenza) AND ([DenominazioneDipendenza] = @Original_DenominazioneDipendenza) AND ([IdProvincia] = @Original_IdProvincia) AND ([SiglaProvincia] = @Original_SiglaProvincia) AND ([DataUltimaModifica] = @Original_DataUltimaModifica));
SELECT IdUtente, Nome, Cognome, CodiceFiscale, IscrittoSilcea, Email, IdSocieta, DenominazioneSocieta, IdDipendenza, DenominazioneDipendenza, IdProvincia, SiglaProvincia, DataUltimaModifica FROM Utenti WHERE (IdUtente = @IdUtente)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodiceFiscale" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@IscrittoSilcea" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="IscrittoSilcea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenominazioneSocieta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneSocieta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DenominazioneDipendenza" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneDipendenza" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SiglaProvincia" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SiglaProvincia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataUltimaModifica" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataUltimaModifica" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cognome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cognome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodiceFiscale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodiceFiscale" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodiceFiscale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_IscrittoSilcea" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="IscrittoSilcea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdSocieta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenominazioneSocieta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneSocieta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDipendenza" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DenominazioneDipendenza" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DenominazioneDipendenza" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProvincia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SiglaProvincia" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SiglaProvincia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataUltimaModifica" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataUltimaModifica" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdUtente" ColumnName="IdUtente" DataSourceName="nSynDB.dbo.Utenti" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdUtente" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdUtente" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdUtente" DataSetColumn="IdUtente" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Cognome" DataSetColumn="Cognome" />
              <Mapping SourceColumn="CodiceFiscale" DataSetColumn="CodiceFiscale" />
              <Mapping SourceColumn="IscrittoSilcea" DataSetColumn="IscrittoSilcea" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="IdSocieta" DataSetColumn="IdSocieta" />
              <Mapping SourceColumn="DenominazioneSocieta" DataSetColumn="DenominazioneSocieta" />
              <Mapping SourceColumn="IdDipendenza" DataSetColumn="IdDipendenza" />
              <Mapping SourceColumn="DenominazioneDipendenza" DataSetColumn="DenominazioneDipendenza" />
              <Mapping SourceColumn="IdProvincia" DataSetColumn="IdProvincia" />
              <Mapping SourceColumn="SiglaProvincia" DataSetColumn="SiglaProvincia" />
              <Mapping SourceColumn="DataUltimaModifica" DataSetColumn="DataUltimaModifica" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ListaUtentiTableAdapter" GeneratorDataComponentClassName="ListaUtentiTableAdapter" Name="ListaUtenti" UserDataComponentName="ListaUtentiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.ListaUtenti" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ListaUtenti</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataRiferimento" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@TipologiaQuery" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Cognome" DataSetColumn="Cognome" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="DenominazioneSocieta" DataSetColumn="DenominazioneSocieta" />
              <Mapping SourceColumn="DenominazioneDipendenza" DataSetColumn="DenominazioneDipendenza" />
              <Mapping SourceColumn="DenominazioneProvincia" DataSetColumn="DenominazioneProvincia" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ElencoMesiTableAdapter" GeneratorDataComponentClassName="ElencoMesiTableAdapter" Name="ElencoMesi" UserDataComponentName="ElencoMesiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.ElencoMesi" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ElencoMesi</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@TipologiaQuery" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DataRiferimento" DataSetColumn="DataRiferimento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RicercaElencoTelefonicoTableAdapter" GeneratorDataComponentClassName="RicercaElencoTelefonicoTableAdapter" Name="RicercaElencoTelefonico" UserDataComponentName="RicercaElencoTelefonicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.RicercaElencoTelefonico" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.RicercaElencoTelefonico</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nominativo" Precision="0" ProviderType="VarChar" Scale="0" Size="200" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@reparto" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Nominativo" DataSetColumn="Nominativo" />
              <Mapping SourceColumn="Societa" DataSetColumn="Societa" />
              <Mapping SourceColumn="Reparto" DataSetColumn="Reparto" />
              <Mapping SourceColumn="Ruolo" DataSetColumn="Ruolo" />
              <Mapping SourceColumn="NumeroUrbano" DataSetColumn="NumeroUrbano" />
              <Mapping SourceColumn="FAXNumeroUrbano" DataSetColumn="FAXNumeroUrbano" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.InserisciUtente" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InserisciUtente" MethodsParameterType="CLR" Modifier="Public" Name="InserisciUtente" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InserisciUtente">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.InserisciUtente</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@DenominazioneSocieta" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ABI" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Cognome" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CodiceFiscale" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ComuneDipendenza" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Provincia" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CAP" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SiglaProvincia" Precision="0" ProviderType="Char" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="money" DbType="Currency" Direction="Input" ParameterName="@Contributi" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@DataContributo" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="nSynDBConnectionString (Settings)" DbObjectName="nSynDB.dbo.ListaUtenti" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="ListaUtenti" MethodsParameterType="CLR" Modifier="Public" Name="ListaUtenti" QueryType="NoData" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="ListaUtenti">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.ListaUtenti</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataRiferimento" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@TipologiaQuery" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="nSynDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="nSynDBDataSet" msprop:Generator_DataSetName="nSynDBDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Dipendenze" msprop:Generator_UserTableName="Dipendenze" msprop:Generator_RowDeletedName="DipendenzeRowDeleted" msprop:Generator_RowChangedName="DipendenzeRowChanged" msprop:Generator_RowClassName="DipendenzeRow" msprop:Generator_RowChangingName="DipendenzeRowChanging" msprop:Generator_RowEvArgName="DipendenzeRowChangeEvent" msprop:Generator_RowEvHandlerName="DipendenzeRowChangeEventHandler" msprop:Generator_TableClassName="DipendenzeDataTable" msprop:Generator_TableVarName="tableDipendenze" msprop:Generator_RowDeletingName="DipendenzeRowDeleting" msprop:Generator_TablePropName="Dipendenze">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdDipendenza" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdDipendenza" msprop:Generator_ColumnVarNameInTable="columnIdDipendenza" msprop:Generator_ColumnPropNameInRow="IdDipendenza" msprop:Generator_ColumnPropNameInTable="IdDipendenzaColumn" type="xs:int" />
              <xs:element name="IdSocieta" msprop:Generator_UserColumnName="IdSocieta" msprop:Generator_ColumnVarNameInTable="columnIdSocieta" msprop:Generator_ColumnPropNameInRow="IdSocieta" msprop:Generator_ColumnPropNameInTable="IdSocietaColumn" type="xs:int" />
              <xs:element name="Denominazione" msprop:Generator_UserColumnName="Denominazione" msprop:Generator_ColumnVarNameInTable="columnDenominazione" msprop:Generator_ColumnPropNameInRow="Denominazione" msprop:Generator_ColumnPropNameInTable="DenominazioneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Indirizzo" msprop:Generator_UserColumnName="Indirizzo" msprop:Generator_ColumnVarNameInTable="columnIndirizzo" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CAB" msprop:Generator_UserColumnName="CAB" msprop:Generator_ColumnVarNameInTable="columnCAB" msprop:Generator_ColumnPropNameInRow="CAB" msprop:Generator_ColumnPropNameInTable="CABColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Comune" msprop:Generator_UserColumnName="Comune" msprop:Generator_ColumnVarNameInTable="columnComune" msprop:Generator_ColumnPropNameInRow="Comune" msprop:Generator_ColumnPropNameInTable="ComuneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdProvincia" msprop:Generator_UserColumnName="IdProvincia" msprop:Generator_ColumnVarNameInTable="columnIdProvincia" msprop:Generator_ColumnPropNameInRow="IdProvincia" msprop:Generator_ColumnPropNameInTable="IdProvinciaColumn" type="xs:int" />
              <xs:element name="CAP" msprop:Generator_UserColumnName="CAP" msprop:Generator_ColumnVarNameInTable="columnCAP" msprop:Generator_ColumnPropNameInRow="CAP" msprop:Generator_ColumnPropNameInTable="CAPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DataInizio" msprop:Generator_UserColumnName="DataInizio" msprop:Generator_ColumnVarNameInTable="columnDataInizio" msprop:Generator_ColumnPropNameInRow="DataInizio" msprop:Generator_ColumnPropNameInTable="DataInizioColumn" type="xs:dateTime" />
              <xs:element name="DataFine" msprop:Generator_UserColumnName="DataFine" msprop:Generator_ColumnVarNameInTable="columnDataFine" msprop:Generator_ColumnPropNameInRow="DataFine" msprop:Generator_ColumnPropNameInTable="DataFineColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InformazioniAssegnazione" msprop:Generator_UserTableName="InformazioniAssegnazione" msprop:Generator_RowDeletedName="InformazioniAssegnazioneRowDeleted" msprop:Generator_RowChangedName="InformazioniAssegnazioneRowChanged" msprop:Generator_RowClassName="InformazioniAssegnazioneRow" msprop:Generator_RowChangingName="InformazioniAssegnazioneRowChanging" msprop:Generator_RowEvArgName="InformazioniAssegnazioneRowChangeEvent" msprop:Generator_RowEvHandlerName="InformazioniAssegnazioneRowChangeEventHandler" msprop:Generator_TableClassName="InformazioniAssegnazioneDataTable" msprop:Generator_TableVarName="tableInformazioniAssegnazione" msprop:Generator_RowDeletingName="InformazioniAssegnazioneRowDeleting" msprop:Generator_TablePropName="InformazioniAssegnazione">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdAssegnazione" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdAssegnazione" msprop:Generator_ColumnVarNameInTable="columnIdAssegnazione" msprop:Generator_ColumnPropNameInRow="IdAssegnazione" msprop:Generator_ColumnPropNameInTable="IdAssegnazioneColumn" type="xs:int" />
              <xs:element name="IdUtente" msprop:Generator_UserColumnName="IdUtente" msprop:Generator_ColumnVarNameInTable="columnIdUtente" msprop:Generator_ColumnPropNameInRow="IdUtente" msprop:Generator_ColumnPropNameInTable="IdUtenteColumn" type="xs:int" />
              <xs:element name="IdSocieta" msprop:Generator_UserColumnName="IdSocieta" msprop:Generator_ColumnVarNameInTable="columnIdSocieta" msprop:Generator_ColumnPropNameInRow="IdSocieta" msprop:Generator_ColumnPropNameInTable="IdSocietaColumn" type="xs:int" />
              <xs:element name="IdDipendenza" msprop:Generator_UserColumnName="IdDipendenza" msprop:Generator_ColumnVarNameInTable="columnIdDipendenza" msprop:Generator_ColumnPropNameInRow="IdDipendenza" msprop:Generator_ColumnPropNameInTable="IdDipendenzaColumn" type="xs:int" />
              <xs:element name="DataInizio" msprop:Generator_UserColumnName="DataInizio" msprop:Generator_ColumnVarNameInTable="columnDataInizio" msprop:Generator_ColumnPropNameInRow="DataInizio" msprop:Generator_ColumnPropNameInTable="DataInizioColumn" type="xs:dateTime" />
              <xs:element name="DataFine" msprop:Generator_UserColumnName="DataFine" msprop:Generator_ColumnVarNameInTable="columnDataFine" msprop:Generator_ColumnPropNameInRow="DataFine" msprop:Generator_ColumnPropNameInTable="DataFineColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ModificheUtenti" msprop:Generator_UserTableName="ModificheUtenti" msprop:Generator_RowDeletedName="ModificheUtentiRowDeleted" msprop:Generator_RowChangedName="ModificheUtentiRowChanged" msprop:Generator_RowClassName="ModificheUtentiRow" msprop:Generator_RowChangingName="ModificheUtentiRowChanging" msprop:Generator_RowEvArgName="ModificheUtentiRowChangeEvent" msprop:Generator_RowEvHandlerName="ModificheUtentiRowChangeEventHandler" msprop:Generator_TableClassName="ModificheUtentiDataTable" msprop:Generator_TableVarName="tableModificheUtenti" msprop:Generator_RowDeletingName="ModificheUtentiRowDeleting" msprop:Generator_TablePropName="ModificheUtenti">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdModifica" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdModifica" msprop:Generator_ColumnVarNameInTable="columnIdModifica" msprop:Generator_ColumnPropNameInRow="IdModifica" msprop:Generator_ColumnPropNameInTable="IdModificaColumn" type="xs:int" />
              <xs:element name="IdUtente" msprop:Generator_UserColumnName="IdUtente" msprop:Generator_ColumnVarNameInTable="columnIdUtente" msprop:Generator_ColumnPropNameInRow="IdUtente" msprop:Generator_ColumnPropNameInTable="IdUtenteColumn" type="xs:int" />
              <xs:element name="TipologiaModifica" msprop:Generator_UserColumnName="TipologiaModifica" msprop:Generator_ColumnVarNameInTable="columnTipologiaModifica" msprop:Generator_ColumnPropNameInRow="TipologiaModifica" msprop:Generator_ColumnPropNameInTable="TipologiaModificaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValoreContributo" msprop:Generator_UserColumnName="ValoreContributo" msprop:Generator_ColumnVarNameInTable="columnValoreContributo" msprop:Generator_ColumnPropNameInRow="ValoreContributo" msprop:Generator_ColumnPropNameInTable="ValoreContributoColumn" type="xs:decimal" />
              <xs:element name="DataModifica" msprop:Generator_UserColumnName="DataModifica" msprop:Generator_ColumnVarNameInTable="columnDataModifica" msprop:Generator_ColumnPropNameInRow="DataModifica" msprop:Generator_ColumnPropNameInTable="DataModificaColumn" type="xs:dateTime" />
              <xs:element name="DataInserimento" msprop:Generator_UserColumnName="DataInserimento" msprop:Generator_ColumnVarNameInTable="columnDataInserimento" msprop:Generator_ColumnPropNameInRow="DataInserimento" msprop:Generator_ColumnPropNameInTable="DataInserimentoColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Provincie" msprop:Generator_UserTableName="Provincie" msprop:Generator_RowDeletedName="ProvincieRowDeleted" msprop:Generator_RowChangedName="ProvincieRowChanged" msprop:Generator_RowClassName="ProvincieRow" msprop:Generator_RowChangingName="ProvincieRowChanging" msprop:Generator_RowEvArgName="ProvincieRowChangeEvent" msprop:Generator_RowEvHandlerName="ProvincieRowChangeEventHandler" msprop:Generator_TableClassName="ProvincieDataTable" msprop:Generator_TableVarName="tableProvincie" msprop:Generator_RowDeletingName="ProvincieRowDeleting" msprop:Generator_TablePropName="Provincie">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdProvincia" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdProvincia" msprop:Generator_ColumnVarNameInTable="columnIdProvincia" msprop:Generator_ColumnPropNameInRow="IdProvincia" msprop:Generator_ColumnPropNameInTable="IdProvinciaColumn" type="xs:int" />
              <xs:element name="Denominazione" msprop:Generator_UserColumnName="Denominazione" msprop:Generator_ColumnVarNameInTable="columnDenominazione" msprop:Generator_ColumnPropNameInRow="Denominazione" msprop:Generator_ColumnPropNameInTable="DenominazioneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sigla" msprop:Generator_UserColumnName="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataInizio" msprop:Generator_UserColumnName="DataInizio" msprop:Generator_ColumnVarNameInTable="columnDataInizio" msprop:Generator_ColumnPropNameInRow="DataInizio" msprop:Generator_ColumnPropNameInTable="DataInizioColumn" type="xs:dateTime" />
              <xs:element name="DataFine" msprop:Generator_UserColumnName="DataFine" msprop:Generator_ColumnVarNameInTable="columnDataFine" msprop:Generator_ColumnPropNameInRow="DataFine" msprop:Generator_ColumnPropNameInTable="DataFineColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Societa" msprop:Generator_UserTableName="Societa" msprop:Generator_RowDeletedName="SocietaRowDeleted" msprop:Generator_RowChangedName="SocietaRowChanged" msprop:Generator_RowClassName="SocietaRow" msprop:Generator_RowChangingName="SocietaRowChanging" msprop:Generator_RowEvArgName="SocietaRowChangeEvent" msprop:Generator_RowEvHandlerName="SocietaRowChangeEventHandler" msprop:Generator_TableClassName="SocietaDataTable" msprop:Generator_TableVarName="tableSocieta" msprop:Generator_RowDeletingName="SocietaRowDeleting" msprop:Generator_TablePropName="Societa">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdSocieta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdSocieta" msprop:Generator_ColumnVarNameInTable="columnIdSocieta" msprop:Generator_ColumnPropNameInRow="IdSocieta" msprop:Generator_ColumnPropNameInTable="IdSocietaColumn" type="xs:int" />
              <xs:element name="Denominazione" msprop:Generator_UserColumnName="Denominazione" msprop:Generator_ColumnVarNameInTable="columnDenominazione" msprop:Generator_ColumnPropNameInRow="Denominazione" msprop:Generator_ColumnPropNameInTable="DenominazioneColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ABI" msprop:Generator_UserColumnName="ABI" msprop:Generator_ColumnVarNameInTable="columnABI" msprop:Generator_ColumnPropNameInRow="ABI" msprop:Generator_ColumnPropNameInTable="ABIColumn" type="xs:int" />
              <xs:element name="DataInizio" msprop:Generator_UserColumnName="DataInizio" msprop:Generator_ColumnVarNameInTable="columnDataInizio" msprop:Generator_ColumnPropNameInRow="DataInizio" msprop:Generator_ColumnPropNameInTable="DataInizioColumn" type="xs:dateTime" />
              <xs:element name="DataFine" msprop:Generator_UserColumnName="DataFine" msprop:Generator_ColumnVarNameInTable="columnDataFine" msprop:Generator_ColumnPropNameInRow="DataFine" msprop:Generator_ColumnPropNameInTable="DataFineColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Utenti" msprop:Generator_UserTableName="Utenti" msprop:Generator_RowDeletedName="UtentiRowDeleted" msprop:Generator_RowChangedName="UtentiRowChanged" msprop:Generator_RowClassName="UtentiRow" msprop:Generator_RowChangingName="UtentiRowChanging" msprop:Generator_RowEvArgName="UtentiRowChangeEvent" msprop:Generator_RowEvHandlerName="UtentiRowChangeEventHandler" msprop:Generator_TableClassName="UtentiDataTable" msprop:Generator_TableVarName="tableUtenti" msprop:Generator_RowDeletingName="UtentiRowDeleting" msprop:Generator_TablePropName="Utenti">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdUtente" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdUtente" msprop:Generator_ColumnVarNameInTable="columnIdUtente" msprop:Generator_ColumnPropNameInRow="IdUtente" msprop:Generator_ColumnPropNameInTable="IdUtenteColumn" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cognome" msprop:Generator_UserColumnName="Cognome" msprop:Generator_ColumnVarNameInTable="columnCognome" msprop:Generator_ColumnPropNameInRow="Cognome" msprop:Generator_ColumnPropNameInTable="CognomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodiceFiscale" msprop:Generator_UserColumnName="CodiceFiscale" msprop:Generator_ColumnVarNameInTable="columnCodiceFiscale" msprop:Generator_ColumnPropNameInRow="CodiceFiscale" msprop:Generator_ColumnPropNameInTable="CodiceFiscaleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IscrittoSilcea" msprop:Generator_UserColumnName="IscrittoSilcea" msprop:Generator_ColumnVarNameInTable="columnIscrittoSilcea" msprop:Generator_ColumnPropNameInRow="IscrittoSilcea" msprop:Generator_ColumnPropNameInTable="IscrittoSilceaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdSocieta" msprop:Generator_UserColumnName="IdSocieta" msprop:Generator_ColumnVarNameInTable="columnIdSocieta" msprop:Generator_ColumnPropNameInRow="IdSocieta" msprop:Generator_ColumnPropNameInTable="IdSocietaColumn" type="xs:int" />
              <xs:element name="DenominazioneSocieta" msprop:Generator_UserColumnName="DenominazioneSocieta" msprop:Generator_ColumnVarNameInTable="columnDenominazioneSocieta" msprop:Generator_ColumnPropNameInRow="DenominazioneSocieta" msprop:Generator_ColumnPropNameInTable="DenominazioneSocietaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdDipendenza" msprop:Generator_UserColumnName="IdDipendenza" msprop:Generator_ColumnVarNameInTable="columnIdDipendenza" msprop:Generator_ColumnPropNameInRow="IdDipendenza" msprop:Generator_ColumnPropNameInTable="IdDipendenzaColumn" type="xs:int" />
              <xs:element name="DenominazioneDipendenza" msprop:Generator_UserColumnName="DenominazioneDipendenza" msprop:Generator_ColumnVarNameInTable="columnDenominazioneDipendenza" msprop:Generator_ColumnPropNameInRow="DenominazioneDipendenza" msprop:Generator_ColumnPropNameInTable="DenominazioneDipendenzaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdProvincia" msprop:Generator_UserColumnName="IdProvincia" msprop:Generator_ColumnVarNameInTable="columnIdProvincia" msprop:Generator_ColumnPropNameInRow="IdProvincia" msprop:Generator_ColumnPropNameInTable="IdProvinciaColumn" type="xs:int" />
              <xs:element name="SiglaProvincia" msprop:Generator_UserColumnName="SiglaProvincia" msprop:Generator_ColumnVarNameInTable="columnSiglaProvincia" msprop:Generator_ColumnPropNameInRow="SiglaProvincia" msprop:Generator_ColumnPropNameInTable="SiglaProvinciaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataUltimaModifica" msprop:Generator_UserColumnName="DataUltimaModifica" msprop:Generator_ColumnVarNameInTable="columnDataUltimaModifica" msprop:Generator_ColumnPropNameInRow="DataUltimaModifica" msprop:Generator_ColumnPropNameInTable="DataUltimaModificaColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ListaUtenti" msprop:Generator_UserTableName="ListaUtenti" msprop:Generator_RowDeletedName="ListaUtentiRowDeleted" msprop:Generator_RowChangedName="ListaUtentiRowChanged" msprop:Generator_RowClassName="ListaUtentiRow" msprop:Generator_RowChangingName="ListaUtentiRowChanging" msprop:Generator_RowEvArgName="ListaUtentiRowChangeEvent" msprop:Generator_RowEvHandlerName="ListaUtentiRowChangeEventHandler" msprop:Generator_TableClassName="ListaUtentiDataTable" msprop:Generator_TableVarName="tableListaUtenti" msprop:Generator_RowDeletingName="ListaUtentiRowDeleting" msprop:Generator_TablePropName="ListaUtenti">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Cognome" msprop:Generator_UserColumnName="Cognome" msprop:Generator_ColumnVarNameInTable="columnCognome" msprop:Generator_ColumnPropNameInRow="Cognome" msprop:Generator_ColumnPropNameInTable="CognomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenominazioneSocieta" msprop:Generator_UserColumnName="DenominazioneSocieta" msprop:Generator_ColumnVarNameInTable="columnDenominazioneSocieta" msprop:Generator_ColumnPropNameInRow="DenominazioneSocieta" msprop:Generator_ColumnPropNameInTable="DenominazioneSocietaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenominazioneDipendenza" msprop:Generator_UserColumnName="DenominazioneDipendenza" msprop:Generator_ColumnVarNameInTable="columnDenominazioneDipendenza" msprop:Generator_ColumnPropNameInRow="DenominazioneDipendenza" msprop:Generator_ColumnPropNameInTable="DenominazioneDipendenzaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DenominazioneProvincia" msprop:Generator_UserColumnName="DenominazioneProvincia" msprop:Generator_ColumnVarNameInTable="columnDenominazioneProvincia" msprop:Generator_ColumnPropNameInRow="DenominazioneProvincia" msprop:Generator_ColumnPropNameInTable="DenominazioneProvinciaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ElencoMesi" msprop:Generator_UserTableName="ElencoMesi" msprop:Generator_RowDeletedName="ElencoMesiRowDeleted" msprop:Generator_RowChangedName="ElencoMesiRowChanged" msprop:Generator_RowClassName="ElencoMesiRow" msprop:Generator_RowChangingName="ElencoMesiRowChanging" msprop:Generator_RowEvArgName="ElencoMesiRowChangeEvent" msprop:Generator_RowEvHandlerName="ElencoMesiRowChangeEventHandler" msprop:Generator_TableClassName="ElencoMesiDataTable" msprop:Generator_TableVarName="tableElencoMesi" msprop:Generator_RowDeletingName="ElencoMesiRowDeleting" msprop:Generator_TablePropName="ElencoMesi">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DataRiferimento" msprop:Generator_UserColumnName="DataRiferimento" msprop:Generator_ColumnPropNameInRow="DataRiferimento" msprop:Generator_ColumnVarNameInTable="columnDataRiferimento" msprop:Generator_ColumnPropNameInTable="DataRiferimentoColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RicercaElencoTelefonico" msprop:Generator_UserTableName="RicercaElencoTelefonico" msprop:Generator_RowDeletedName="RicercaElencoTelefonicoRowDeleted" msprop:Generator_TableClassName="RicercaElencoTelefonicoDataTable" msprop:Generator_RowChangedName="RicercaElencoTelefonicoRowChanged" msprop:Generator_RowClassName="RicercaElencoTelefonicoRow" msprop:Generator_RowChangingName="RicercaElencoTelefonicoRowChanging" msprop:Generator_RowEvArgName="RicercaElencoTelefonicoRowChangeEvent" msprop:Generator_RowEvHandlerName="RicercaElencoTelefonicoRowChangeEventHandler" msprop:Generator_TablePropName="RicercaElencoTelefonico" msprop:Generator_TableVarName="tableRicercaElencoTelefonico" msprop:Generator_RowDeletingName="RicercaElencoTelefonicoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Nominativo" msprop:Generator_UserColumnName="Nominativo" msprop:Generator_ColumnPropNameInRow="Nominativo" msprop:Generator_ColumnVarNameInTable="columnNominativo" msprop:Generator_ColumnPropNameInTable="NominativoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Societa" msprop:Generator_UserColumnName="Societa" msprop:Generator_ColumnPropNameInRow="Societa" msprop:Generator_ColumnVarNameInTable="columnSocieta" msprop:Generator_ColumnPropNameInTable="SocietaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reparto" msprop:Generator_UserColumnName="Reparto" msprop:Generator_ColumnPropNameInRow="Reparto" msprop:Generator_ColumnVarNameInTable="columnReparto" msprop:Generator_ColumnPropNameInTable="RepartoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ruolo" msprop:Generator_UserColumnName="Ruolo" msprop:Generator_ColumnPropNameInRow="Ruolo" msprop:Generator_ColumnVarNameInTable="columnRuolo" msprop:Generator_ColumnPropNameInTable="RuoloColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumeroUrbano" msprop:Generator_UserColumnName="NumeroUrbano" msprop:Generator_ColumnPropNameInRow="NumeroUrbano" msprop:Generator_ColumnVarNameInTable="columnNumeroUrbano" msprop:Generator_ColumnPropNameInTable="NumeroUrbanoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FAXNumeroUrbano" msprop:Generator_UserColumnName="FAXNumeroUrbano" msprop:Generator_ColumnPropNameInRow="FAXNumeroUrbano" msprop:Generator_ColumnVarNameInTable="columnFAXNumeroUrbano" msprop:Generator_ColumnPropNameInTable="FAXNumeroUrbanoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Dipendenze" />
      <xs:field xpath="mstns:IdDipendenza" />
    </xs:unique>
    <xs:unique name="InformazioniAssegnazione_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InformazioniAssegnazione" />
      <xs:field xpath="mstns:IdAssegnazione" />
    </xs:unique>
    <xs:unique name="ModificheUtenti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ModificheUtenti" />
      <xs:field xpath="mstns:IdModifica" />
    </xs:unique>
    <xs:unique name="Provincie_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Provincie" />
      <xs:field xpath="mstns:IdProvincia" />
    </xs:unique>
    <xs:unique name="Societa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Societa" />
      <xs:field xpath="mstns:IdSocieta" />
    </xs:unique>
    <xs:unique name="Utenti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Utenti" />
      <xs:field xpath="mstns:IdUtente" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Dipendenze_Banche" msdata:parent="Societa" msdata:child="Dipendenze" msdata:parentkey="IdSocieta" msdata:childkey="IdSocieta" msprop:Generator_UserRelationName="FK_Dipendenze_Banche" msprop:Generator_RelationVarName="relationFK_Dipendenze_Banche" msprop:Generator_UserChildTable="Dipendenze" msprop:Generator_UserParentTable="Societa" msprop:Generator_ParentPropName="SocietaRow" msprop:Generator_ChildPropName="GetDipendenzeRows" />
      <msdata:Relationship name="FK_Dipendenze_Provincie" msdata:parent="Provincie" msdata:child="Dipendenze" msdata:parentkey="IdProvincia" msdata:childkey="IdProvincia" msprop:Generator_UserRelationName="FK_Dipendenze_Provincie" msprop:Generator_RelationVarName="relationFK_Dipendenze_Provincie" msprop:Generator_UserChildTable="Dipendenze" msprop:Generator_UserParentTable="Provincie" msprop:Generator_ParentPropName="ProvincieRow" msprop:Generator_ChildPropName="GetDipendenzeRows" />
      <msdata:Relationship name="FK_InformazioniAssegnazione_Banche" msdata:parent="Societa" msdata:child="InformazioniAssegnazione" msdata:parentkey="IdSocieta" msdata:childkey="IdSocieta" msprop:Generator_UserRelationName="FK_InformazioniAssegnazione_Banche" msprop:Generator_RelationVarName="relationFK_InformazioniAssegnazione_Banche" msprop:Generator_UserChildTable="InformazioniAssegnazione" msprop:Generator_UserParentTable="Societa" msprop:Generator_ParentPropName="SocietaRow" msprop:Generator_ChildPropName="GetInformazioniAssegnazioneRows" />
      <msdata:Relationship name="FK_InformazioniAssegnazione_Dipendenze" msdata:parent="Dipendenze" msdata:child="InformazioniAssegnazione" msdata:parentkey="IdDipendenza" msdata:childkey="IdDipendenza" msprop:Generator_UserRelationName="FK_InformazioniAssegnazione_Dipendenze" msprop:Generator_RelationVarName="relationFK_InformazioniAssegnazione_Dipendenze" msprop:Generator_UserChildTable="InformazioniAssegnazione" msprop:Generator_UserParentTable="Dipendenze" msprop:Generator_ParentPropName="DipendenzeRow" msprop:Generator_ChildPropName="GetInformazioniAssegnazioneRows" />
      <msdata:Relationship name="FK_InformazioniAssegnazione_Utenti" msdata:parent="Utenti" msdata:child="InformazioniAssegnazione" msdata:parentkey="IdUtente" msdata:childkey="IdUtente" msprop:Generator_UserRelationName="FK_InformazioniAssegnazione_Utenti" msprop:Generator_RelationVarName="relationFK_InformazioniAssegnazione_Utenti" msprop:Generator_UserChildTable="InformazioniAssegnazione" msprop:Generator_UserParentTable="Utenti" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_ChildPropName="GetInformazioniAssegnazioneRows" />
      <msdata:Relationship name="FK_ContributiUtenti_Utenti" msdata:parent="Utenti" msdata:child="ModificheUtenti" msdata:parentkey="IdUtente" msdata:childkey="IdUtente" msprop:Generator_UserRelationName="FK_ContributiUtenti_Utenti" msprop:Generator_RelationVarName="relationFK_ContributiUtenti_Utenti" msprop:Generator_UserChildTable="ModificheUtenti" msprop:Generator_UserParentTable="Utenti" msprop:Generator_ParentPropName="UtentiRow" msprop:Generator_ChildPropName="GetModificheUtentiRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>